#!/bin/bash

sql_cmd="create table if not exists i_acrm_transaction(customer_id string,tran_date string,tran_type string, channel string, amount bigint) row format delimited fields terminated by ',' collection items terminated by '\n' stored as textfile;"

$HIVE_HOME/bin/hive -e "$sql_cmd"
